<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Virtual Machine Candidates for Retiring/Re-Sizing</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total VMs</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Total VMs">
			<contents><textItem><dataSource><dataItemValue refDataItem="VM Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total VM's with Apps</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="VM Perf Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="App Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>In-Active Hosts</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="VM Perf Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="Sum of Hosts"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Under-Sized Hosts</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Undersized Hosts">
			<contents><textItem><dataSource><dataItemValue refDataItem="Host Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Breached Hosts</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="VM Perf Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="Breached Hosts Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 VM Hosts</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Latency (ms) 30 day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Top High Latency VMs" name="Combination Chart1" depth="25">
																										<v2_combinationTypeTooltips/>
																										<v2_legend>
																											<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="VM Host"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																													<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Latency (ms)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="### ms"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.## ms"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:430px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										
																										</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Least Active Hosts</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Count by IOpS &lt; 10 for 30 days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="VM Perf Detail" name="Combination Chart2" depth="25">
							<v2_combinationTypeTooltips/>
							<v2_legend>
								<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Config"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
										<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Host Count"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange>
										<v2_automaticRange/>
									</v2_axisRange>
									<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### Count"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
							</v2_topLeftAxis>
							<style>
								<CSS value="width:430px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
							
							<v2_defaultChartMeasure refDataItem="Sum of Hosts"/><v2_notes><v2_note refQuery="VM Perf Detail"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>No Data Meeting Criteria</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="color:#DBDBDB;font-family:Arial;font-size:18px;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition><conditionalRender refVariable="showLabel1"><renderFor refVariableValue="1"/></conditionalRender><propertyList><propertyItem refDataItem="Sum of Hosts"/></propertyList></v2_note></v2_notes></v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Undersized Hosts</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(1 CPU &gt; 700 IOpS for 30 days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Undersized Hosts" name="Combination Chart3" depth="25">
							<v2_combinationTypeTooltips/>
							<v2_legend>
								<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
							<v2_commonAxis>
								<v2_ordinalAxis>
									<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="VM Host"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
							<v2_topLeftAxis>
								<v2_combinationChartTypes>
									<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
										<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
								</v2_combinationChartTypes>
								<v2_axis>
									<v2_axisRange>
										<v2_automaticRange/>
									</v2_axisRange>
									<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
							</v2_topLeftAxis>
							<style>
								<CSS value="width:430px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
							
							<v2_notes><v2_note refQuery="Undersized Hosts"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>No Data Meeting Criteria</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="color:#DBDBDB;font-family:Arial;font-size:18px;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition><conditionalRender refVariable="showLabel2"><renderFor refVariableValue="1"/></conditionalRender></v2_note></v2_notes></v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-top:5px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>VM Host Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Breach: </staticValue></dataSource><style><CSS value="font-size:10px;color:#454545"/></style></textItem></contents><style><CSS value="background-color:#FFB2C1"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>VM's with Latency &gt; 50 and at least 4 CPUs</staticValue></dataSource><style><CSS value="font-size:10px;color:#454545"/></style></textItem></contents><style><CSS value="padding-left:10px"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:15px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="VM Perf Detail">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VM Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="VM Host"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Config"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Config"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="CPUs"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="CPUs"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Memory"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Memory"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Provisioned (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VMDK"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="VMDK"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Store"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Store"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Latency (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Latency (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Status"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Latency (ms)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>4.9 Virtual Machine Candidates for Retiring or Resizing</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="VM Perf Detail">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
vmdetail.Application as 'Application',
vmdetail.VMHost as 'VM Host',
vmdetail.ConfigurationType as 'Config',
vmdetail.CPUs as 'CPUs',
vmdetail.Memory as 'Memory',
vmdetail.ProvisionedGB as 'Provisioned (GB)',
vmdetail.UsedGB as 'Used (GB)',
perf.VMDK as 'VMDK',
perf.DataStore as 'Data Store',
perf.Storage as 'Storage Name',
perf.Tier as 'Tier',
ROUND(SUM(perf.totaliops),0) as 'Total IOpS',
ROUND(SUM(perf.latency),2) as 'Latency (ms)'

FROM (

SELECT
dwh_inventory.application.name as 'Application',
dwh_inventory.hv_virtual_machine.name as 'VMHost',
dwh_inventory.hv_virtual_machine.id as vmid,

CASE 
	WHEN dwh_inventory.hv_virtual_machine.processors=1 THEN 't2.small'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=2 THEN 'm4.large'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=4 THEN 'm4.xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=8 THEN 'm4.2xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=16 THEN 'm4.4xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(dwh_inventory.hv_virtual_machine.processors is null, null, 'm4.16xlarge')
        END AS 'ConfigurationType',

dwh_inventory.hv_virtual_machine.processors as 'CPUs',
dwh_inventory.hv_virtual_machine.memory as 'Memory',
ROUND(dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024,2) as 'ProvisionedGB',
ROUND(dwh_inventory.hv_virtual_machine.usedCapacityMB/1024,2) as 'UsedGB'


FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.vm_to_application
ON   dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid

GROUP BY dwh_inventory.application.id, dwh_inventory.hv_virtual_machine.id ) vmdetail

JOIN

(
SELECT
dwh_performance.vm_dimension.id as vmid,
dwh_performance.vmdk_dimension.name as 'VMDK',
dwh_performance.datastore_dimension.name as 'DataStore',
dwh_performance.storage_dimension.name as 'Storage',
dwh_performance.tier_dimension.name as 'Tier',

SUM(dwh_performance.vmdk_daily_performance_fact.totaliops) as totaliops,
AVG(dwh_performance.vmdk_daily_performance_fact.totalresponsetime) as latency,
dwh_performance.date_dimension.fulldate as 'Date'

FROM dwh_performance.vmdk_daily_performance_fact
JOIN dwh_performance.vm_dimension
ON   dwh_performance.vm_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmtk
JOIN dwh_performance.vmdk_dimension
ON   dwh_performance.vmdk_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmdktk
JOIN dwh_performance.datastore_dimension
ON   dwh_performance.datastore_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datastoretk
JOIN dwh_performance.storage_dimension
ON   dwh_performance.storage_dimension.tk=dwh_performance.vmdk_daily_performance_fact.storagetk
JOIN dwh_performance.tier_dimension
ON   dwh_performance.tier_dimension.tk=dwh_performance.vmdk_daily_performance_fact.tiertk
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN  dwh_performance.vmdk_daily_performance_fact 
ON  dwh_performance.vmdk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 30 DAY 

GROUP BY dwh_performance.vm_dimension.id, dwh_performance.vmdk_dimension.id, dwh_performance.datastore_dimension.id, dwh_performance.storage_dimension.id, dwh_performance.tier_dimension.id

) perf ON perf.vmid=vmdetail.vmid

GROUP BY vmdetail.application, vmdetail.vmhost













</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="VM Host"/><mdProjectedItem name="Config"/><mdProjectedItem name="CPUs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="VMDK"/><mdProjectedItem name="Data Store"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Latency (ms)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="VM Host"><expression>[SQL2].[VM Host]</expression></dataItem><dataItem name="Config"><expression>[SQL2].[Config]</expression></dataItem><dataItem name="CPUs"><expression>[SQL2].[CPUs]</expression></dataItem><dataItem name="Memory"><expression>[SQL2].[Memory]</expression></dataItem><dataItem name="Provisioned (GB)"><expression>[SQL2].[Provisioned (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL2].[Used (GB)]</expression></dataItem><dataItem name="VMDK"><expression>[SQL2].[VMDK]</expression></dataItem><dataItem name="Data Store"><expression>[SQL2].[Data Store]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL2].[Total IOpS]</expression></dataItem><dataItem name="Latency (ms)"><expression>[SQL2].[Latency (ms)]</expression></dataItem><dataItem name="Host Count" aggregate="total"><expression>IF([Total IOpS]&lt;10) THEN (1) ELSE (0)</expression></dataItem><dataItem name="Status"><expression>IF([Latency (ms)] &gt; 50 AND [CPUs] &gt; 2) THEN ('Breach') ELSE ('Good')</expression></dataItem><dataItem name="Sum of Hosts"><expression>total([Host Count] for report)</expression></dataItem><dataItem name="Breached Hosts Count" aggregate="total"><expression>IF([Status]='Breach') THEN (1) ELSE (0)</expression></dataItem><dataItem name="App Count" aggregate="total"><expression>count([Application])</expression></dataItem></selection>
		</query><query name="Top High Latency VMs">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
vmdetail.Application as 'Application',
vmdetail.VMHost as 'VM Host',
vmdetail.ConfigurationType as 'Config',
vmdetail.CPUs as 'CPUs',
vmdetail.Memory as 'Memory',
vmdetail.ProvisionedGB as 'Provisioned (GB)',
vmdetail.UsedGB as 'Used (GB)',
perf.VMDK as 'VMDK',
perf.DataStore as 'Data Store',
perf.Storage as 'Storage Name',
perf.Tier as 'Tier',
ROUND(SUM(perf.totaliops),0) as 'Total IOpS',
ROUND(SUM(perf.latency),2) as 'Latency (ms)'

FROM (

SELECT
dwh_inventory.application.name as 'Application',
dwh_inventory.hv_virtual_machine.name as 'VMHost',
dwh_inventory.hv_virtual_machine.id as vmid,

CASE 
	WHEN dwh_inventory.hv_virtual_machine.processors=1 THEN 't2.small'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=2 THEN 'm4.large'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=4 THEN 'm4.xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=8 THEN 'm4.2xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=16 THEN 'm4.4xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(dwh_inventory.hv_virtual_machine.processors is null, null, 'm4.16xlarge')
        END AS 'ConfigurationType',

dwh_inventory.hv_virtual_machine.processors as 'CPUs',
dwh_inventory.hv_virtual_machine.memory as 'Memory',
ROUND(dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024,2) as 'ProvisionedGB',
ROUND(dwh_inventory.hv_virtual_machine.usedCapacityMB/1024,2) as 'UsedGB'


FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.vm_to_application
ON   dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid

GROUP BY dwh_inventory.application.id, dwh_inventory.hv_virtual_machine.id ) vmdetail

JOIN

(
SELECT
dwh_performance.vm_dimension.id as vmid,
dwh_performance.vmdk_dimension.name as 'VMDK',
dwh_performance.datastore_dimension.name as 'DataStore',
dwh_performance.storage_dimension.name as 'Storage',
dwh_performance.tier_dimension.name as 'Tier',

SUM(dwh_performance.vmdk_daily_performance_fact.totaliops) as totaliops,
AVG(dwh_performance.vmdk_daily_performance_fact.totalresponsetime) as latency,
dwh_performance.date_dimension.fulldate as 'Date'

FROM dwh_performance.vmdk_daily_performance_fact
JOIN dwh_performance.vm_dimension
ON   dwh_performance.vm_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmtk
JOIN dwh_performance.vmdk_dimension
ON   dwh_performance.vmdk_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmdktk
JOIN dwh_performance.datastore_dimension
ON   dwh_performance.datastore_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datastoretk
JOIN dwh_performance.storage_dimension
ON   dwh_performance.storage_dimension.tk=dwh_performance.vmdk_daily_performance_fact.storagetk
JOIN dwh_performance.tier_dimension
ON   dwh_performance.tier_dimension.tk=dwh_performance.vmdk_daily_performance_fact.tiertk
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN  dwh_performance.vmdk_daily_performance_fact 
ON  dwh_performance.vmdk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 30 DAY 

GROUP BY dwh_performance.vm_dimension.id, dwh_performance.vmdk_dimension.id, dwh_performance.datastore_dimension.id, dwh_performance.storage_dimension.id, dwh_performance.tier_dimension.id

) perf ON perf.vmid=vmdetail.vmid

GROUP BY vmdetail.application, vmdetail.vmhost

ORDER BY ROUND(SUM(perf.latency),2) DESC LIMIT 10











</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="VM Host"/><mdProjectedItem name="Config"/><mdProjectedItem name="CPUs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="VMDK"/><mdProjectedItem name="Data Store"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Latency (ms)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem><dataItem name="VM Host"><expression>[SQL3].[VM Host]</expression></dataItem><dataItem name="Config"><expression>[SQL3].[Config]</expression></dataItem><dataItem name="CPUs"><expression>[SQL3].[CPUs]</expression></dataItem><dataItem name="Memory"><expression>[SQL3].[Memory]</expression></dataItem><dataItem name="Provisioned (GB)"><expression>[SQL3].[Provisioned (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL3].[Used (GB)]</expression></dataItem><dataItem name="VMDK"><expression>[SQL3].[VMDK]</expression></dataItem><dataItem name="Data Store"><expression>[SQL3].[Data Store]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL3].[Total IOpS]</expression></dataItem><dataItem name="Latency (ms)" aggregate="average"><expression>[SQL3].[Latency (ms)]</expression></dataItem><dataItem name="App Count" aggregate="count"><expression>COUNT([Application])</expression></dataItem></selection>
		</query><query name="Undersized Hosts">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
vmdetail.Application as 'Application',
vmdetail.VMHost as 'VM Host',
vmdetail.ConfigurationType as 'Config',
vmdetail.CPUs as 'CPUs',
vmdetail.Memory as 'Memory',
vmdetail.ProvisionedGB as 'Provisioned (GB)',
vmdetail.UsedGB as 'Used (GB)',
perf.VMDK as 'VMDK',
perf.DataStore as 'Data Store',
perf.Storage as 'Storage Name',
perf.Tier as 'Tier',
ROUND(SUM(perf.totaliops),0) as 'Total IOpS',
ROUND(SUM(perf.latency),2) as 'Latency (ms)'

FROM (

SELECT
dwh_inventory.application.name as 'Application',
dwh_inventory.hv_virtual_machine.name as 'VMHost',
dwh_inventory.hv_virtual_machine.id as vmid,

CASE 
	WHEN dwh_inventory.hv_virtual_machine.processors=1 THEN 't2.small'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=2 THEN 'm4.large'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=4 THEN 'm4.xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=8 THEN 'm4.2xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=16 THEN 'm4.4xlarge'
	WHEN dwh_inventory.hv_virtual_machine.processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(dwh_inventory.hv_virtual_machine.processors is null, null, 'm4.16xlarge')
        END AS 'ConfigurationType',

dwh_inventory.hv_virtual_machine.processors as 'CPUs',
dwh_inventory.hv_virtual_machine.memory as 'Memory',
ROUND(dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024,2) as 'ProvisionedGB',
ROUND(dwh_inventory.hv_virtual_machine.usedCapacityMB/1024,2) as 'UsedGB'


FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.vm_to_application
ON   dwh_inventory.vm_to_application.vmid=dwh_inventory.hv_virtual_machine.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.vm_to_application.applicationid

GROUP BY dwh_inventory.application.id, dwh_inventory.hv_virtual_machine.id ) vmdetail

JOIN

(
SELECT
dwh_performance.vm_dimension.id as vmid,
dwh_performance.vmdk_dimension.name as 'VMDK',
dwh_performance.datastore_dimension.name as 'DataStore',
dwh_performance.storage_dimension.name as 'Storage',
dwh_performance.tier_dimension.name as 'Tier',

SUM(dwh_performance.vmdk_daily_performance_fact.totaliops) as totaliops,
AVG(dwh_performance.vmdk_daily_performance_fact.totalresponsetime) as latency,
dwh_performance.date_dimension.fulldate as 'Date'

FROM dwh_performance.vmdk_daily_performance_fact
JOIN dwh_performance.vm_dimension
ON   dwh_performance.vm_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmtk
JOIN dwh_performance.vmdk_dimension
ON   dwh_performance.vmdk_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmdktk
JOIN dwh_performance.datastore_dimension
ON   dwh_performance.datastore_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datastoretk
JOIN dwh_performance.storage_dimension
ON   dwh_performance.storage_dimension.tk=dwh_performance.vmdk_daily_performance_fact.storagetk
JOIN dwh_performance.tier_dimension
ON   dwh_performance.tier_dimension.tk=dwh_performance.vmdk_daily_performance_fact.tiertk
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN  dwh_performance.vmdk_daily_performance_fact 
ON  dwh_performance.vmdk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 30 DAY 

GROUP BY dwh_performance.vm_dimension.id, dwh_performance.vmdk_dimension.id, dwh_performance.datastore_dimension.id, dwh_performance.storage_dimension.id, dwh_performance.tier_dimension.id

) perf ON perf.vmid=vmdetail.vmid

GROUP BY vmdetail.application, vmdetail.vmhost

HAVING vmdetail.CPUs &lt;2 AND ROUND(SUM(perf.totaliops),0) &gt; 700 













</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="VM Host"/><mdProjectedItem name="Config"/><mdProjectedItem name="CPUs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="VMDK"/><mdProjectedItem name="Data Store"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Latency (ms)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL4].[Application]</expression></dataItem><dataItem name="VM Host"><expression>[SQL4].[VM Host]</expression></dataItem><dataItem name="Config"><expression>[SQL4].[Config]</expression></dataItem><dataItem name="CPUs"><expression>[SQL4].[CPUs]</expression></dataItem><dataItem name="Memory"><expression>[SQL4].[Memory]</expression></dataItem><dataItem name="Provisioned (GB)"><expression>[SQL4].[Provisioned (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL4].[Used (GB)]</expression></dataItem><dataItem name="VMDK"><expression>[SQL4].[VMDK]</expression></dataItem><dataItem name="Data Store"><expression>[SQL4].[Data Store]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL4].[Storage Name]</expression></dataItem><dataItem name="Tier"><expression>[SQL4].[Tier]</expression></dataItem><dataItem name="Total IOpS" aggregate="total"><expression>[SQL4].[Total IOpS]</expression></dataItem><dataItem name="Latency (ms)"><expression>[SQL4].[Latency (ms)]</expression></dataItem><dataItem name="Host Count" aggregate="total"><expression>count([VM Host])</expression></dataItem></selection>
		</query><query name="Total VMs">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
COUNT(dwh_inventory.hv_virtual_machine.id) as 'VM Count'

FROM dwh_inventory.hv_virtual_machine</sqlText>
		<mdProjectedItems><mdProjectedItem name="VM Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="VM Count" aggregate="total"><expression>[SQL1].[VM Count]</expression></dataItem></selection>
		</query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#454545;background-color:#FFB2C1"/></style><reportCondition>[VM Perf Detail].[Status]='Breach'</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#454545;background-color:#9AD7CD"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles><reportVariables><reportVariable type="boolean" name="showLabel1">
			<reportExpression>[VM Perf Detail].[Sum of Hosts]=0</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable><reportVariable type="boolean" name="showLabel2">
			<reportExpression>[Undersized Hosts].[Total IOpS]&lt;=700</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>